Supplier Import

Introduction

This will import VISN suppliers for UK and Ireland.

download sample supplier import file.

Fields

Visn Supplier Import

Column Position	Header Name	Description	Datatype	Validation	Max length	Mandatory	Default Value	Example
A	DI Group ID	Id of the Group	string	A-Z, 0-9 and all special characters	30	No		ymaA5vcxNWOwzKOdvIMA
B	DI Supplier ID	Id of the Supplier	string	A-Z and 0-9	20	No		lpEfZekDPAabVoyzcFxM
C	ERP Garage ID	External Rate Provider Garage ID	Number	0-9	-	No		1900
D	ERP Garage Group ID	External Rate Provider Garage Group ID	Number	0-9	-	No		768
E	Locale	Locale of the supplier	string	en_GB(The string should be en_GB for uk supplier) or en_IE(The string should be en_IE for Ireland supplier)	-	Yes		en_GB
F	Group ID	Group ID of the supplier	string	A-Z and 0-9	20	Yes		DIVSN10024
G	has FNP	FNB Availability Status	string	Y or N	1	No	N	Y
H	FNP Band	FNP band value	String	Band 1 LA1, Band 2 LA1, Band 3 LA1, Band 5 (M25) LA1, Band 1 LA2, Band 2 LA2, Band 3 LA2, Band 5 (M25) LA2, Band 1 LA3, Band 2 LA3, Band 3 LA3, Band 5 (M25) LA3, NONE	20	Yes		Band 1 LA1
I	Supplier Group Name	Group Name of the supplier	string	A-Z ,0-9 and all special characters	50	No		Bellinger & Sons Vauxhall Wantage
J	Supplier ID	Id of the supplier	string	A-Z ,0-9	20	No		AD13HBG
K	Supplier Name	Name of the supplier	string	A-Z ,0-9 and all special characters	50	No		Ancaster Dartford Renault
L	Paybill	Determines how the suppliers are paid. 1) ViSN Hybrid - Customer's Network and DI Network with Paybill. VISN - Digital INNK will pay the supplier for this customer DIRECT - Customer will pay the supplier directly 2) ViSN with DI Network and Paybill- Digital INNK will pay the suppliers 3) External Rate Provider Paybill - External Rate Provider will pay the suppliers	string	VISN or DIRECT	-	Yes		VISN
M	VAT Registration Number	VAT Registration Number	string	A-Z ,0-9	20	No		VAT1234
N	Company Number	Company Number	string	A-Z ,0-9	20	No		CMP1234
O	Nominated Dealer Manager	Nominated Dealer Manager	string	A-Z ,0-9, hyphen and space	20	Yes		Steve Philips
P	Address 1	Building Number	string	A-Z ,0-9 and all special characters	20	No		88
Q	Address 2	Address 2	string	A-Z ,0-9 and all special characters	50	No		Plaistow Lane
R	Address 3	Address 3	string	A-Z ,0-9 and all special characters	50	No		Bromley
S	Address 4	Address 4	string	A-Z ,0-9 and all special characters	50	No		Kent
T	Address 5	Address 5	string	A-Z ,0-9 and all special characters	50	No		Middlesex
U	Postcode	Postcode	string	Standard UK and Ireland postcode validation	-	Yes		SE20 7TF
V	Region 1	Region 1	string	A-Z ,0-9, hyphen and space	50	No		Evans Halshaw
W	Region 2	Region 2	string	A-Z ,0-9, hyphen and space	50	No		East Sussex
X	Region 3	Region 3	string	A-Z ,0-9, hyphen and space	50	No		BrightonCCC
Y	Primary Phone Number	Primary Phone Number	string	A-Z ,0-9 and all special characters	20	Yes		02082 908700
Z	Booking Phone Number	Booking Phone Number	string	A-Z ,0-9 and all special characters	20	No		02082 908700
AA	Fax Number	Fax Number	string	A-Z ,0-9 and all special characters	20	No		02087 689200
AB	email	email of the supplier	string	A-Z ,0-9 and all special characters	100	No		vishwa@digitalinnk.com
AC	description	description	string	A-Z ,0-9 and all special characters	50	No		supplier from Chelmsford
AD	notes	notes	string	A-Z ,0-9 and all special characters	20	No		Notes
AE	Max Height	Max Height	string	A-Z ,0-9,underscore,hyphen and plus sign	20	No		+123
AF	Max Length	Max Length	string	A-Z ,0-9,underscore,hyphen and plus sign	20	No		-58
AG	Max Weight	Max Weight	string	A-Z ,0-9,underscore,hyphen and plus sign	20	No		77
AH	Last Physical Audit	Last Physical Audit	-	No Validation available for this field	-	No		-
AI	Last Desktop Audit	Last Desktop Audit	-	No Validation available for this field	-	No		-
AJ	Collection Del	Collection Del	string	Y or N	1	No	N	Y
AK	Collection NTD	Collection NTD	string	Y or N	1	No	N	Y
AL	Collection Lead Time	Collection Lead Time	Number	0-9	2	No		44
AM	Collection Radius	Collection Radius	Number	0-9	2	No		22
AN	Collection Notes	Collection Notes	string	A-Z ,0-9 and all special characters	30	No		Collection Notes
AO	Courtesy Car	Courtesy Car	string	Y or N	1	No		Y
AP	Courtesy Car Ntd	Courtesy Car Ntd	string	Y or N	1	No	N	Y
AQ	Courtesy Car Lead Time	Courtesy Car Lead Time	Number	0-9	2	No		22
AR	Courtesy Car Notes	Courtesy Car Notes	string	A-Z ,0-9 and all special characters	30	No		Notes about courtesy car service
AS	While You Wait	While You Wait	string	Y or N	1	No	N	Y
AT	While You Wait NTD	While You Wait NTD	string	Y or N	1	No	N	Y
AU	While You Wait Lead Time	While You Wait Lead Time	Number	0-9	2	No		22
AV	While You Wait Notes	While You Wait Notes	string	A-Z ,0-9 and all special characters	30	No		Notes about while you wait service
AW	Drop Off	Drop Off	string	Y or N	1	No	N	Y
AX	Drop Off NTD	Drop Off NTD	string	Y or N	1	No	N	Y
AY	Drop Off Lead Time	Drop Off Lead Time	Number	0-9	2	No		43
AZ	Out Of Hours	Out Of Hours	string	Y or N	1	No	N	Y
BA	Mobile	Mobile	string	Y or N	1	No	N	Y
BB	Mobile Lead Time	Mobile Off Lead Time	Number	0-9	2	No		43
BC	Mobile Radius	Mobile Radius	Number	0-9	3	No		43
BD	Franchise	Franchise	string	A-Z ,0-9 and all special characters	30	Yes		All
BE	Independent	Independent	string	Y or N	1	No	N	Y
BF	Is On ViSN	Is On ViSN	string	Y or N	1	No	N	Y
BG	Bosch Status	Bosch Status	string	A-Z ,0-9	8	No		-
BH	Network	Network	string	A-Z ,0-9	8	No		-
BI	Network Level	Network Level	string	A-Z ,0-9	8	No		-
BJ	Labour Car	Labour Car	string	0-9 and .(decimal number)	6	No		4.5
BK	Labour Rate LCV	Labour Rate LCV	string	0-9 and .(decimal number)	6	No		4.5
BL	Labour Rate EV	Labour Rate EV	string	0-9 and .(decimal number)	6	No		4.5
BM	Parts Discount	Parts Discount	string	0-9 and .(decimal number)	5	No		94.5
BN	MOT Class1	MOT Class1	string	0-9, .(three digit decimal number)	6	No		941.5
BO	MOT Class2	MOT Class2	string	0-9, .(three digit decimal number)	6	No		941.5
BP	MOT Class3	MOT Class3	string	0-9, .(three digit decimal number)	6	No		941.5
BQ	MOT Class4	MOT Class4	string	0-9, .(three digit decimal number)	6	No		941.5
BR	MOT Class4a	MOT Class4a	string	0-9, .(three digit decimal number)	6	No		941.5
BS	MOT Class5	MOT Class5	string	0-9, .(three digit decimal number)	6	No		941.5
BT	MOT Class5a	MOT Class5a	string	0-9, .(three digit decimal number)	6	No		941.5
BU	MOT Class7	MOT Class7	string	0-9, .(three digit decimal number)	6	No		941.5
BV	Semi Synthetic1	Semi Synthetic1	string	0-9 and .(decimal number)	6	No		4.5
BW	Semi Synthetic2	Semi Synthetic2	string	0-9 and .(decimal number)	6	No		4.5
BX	Synthetic1	Synthetic1	string	0-9 and .(decimal number)	6	No		4.5
BY	Synthetic2	Synthetic2	string	0-9 and .(decimal number)	6	No		4.5
BZ	Synthetic3	Synthetic3	string	0-9 and .(decimal number)	6	No		4.5
CA	Ad Blue	Ad Blue	string	0-9 and .(decimal number)	6	No		4.5
CB	Brake Fluid	Brake Fluid	string	0-9 and .(decimal number)	6	No		4.5
CC	Air Conditioning Coolant	Air Conditioning Coolant	string	0-9 and .(decimal number)	6	No		4.5
CD	Anti Freeze	Anti Freeze	string	0-9 and .(decimal number)	6	No		4.5
CE	Automatic Transmission Fluid	Automatic Transmission Fluid	string	0-9 and .(decimal number)	6	No		4.5
CF	Axle Oil	Axle Oil	string	0-9 and .(decimal number)	6	No		4.5
CG	Gearbox Oil Mineral	Gearbox Oil Mineral	string	0-9 and .(decimal number)	6	No		4.5
CH	Gearbox Oil Synthetic	Gearbox Oil Synthetic	string	0-9 and .(decimal number)	6	No		4.5
CI	Hydraulic Fluid	Hydraulic Fluid	string	0-9 and .(decimal number)	6	No		4.5
CJ	Long Life Oil	Long Life Oil	string	0-9 and .(decimal number)	6	No		4.5
CK	Mineral Oil	Mineral Oil	string	0-9 and .(decimal number)	6	No		4.5
CL	Other Fluid	Other Fluid	string	0-9 and .(decimal number)	6	No		4.5
CM	Power Steering Fluid	Power Steering Fluid	string	0-9 and .(decimal number)	6	No		4.5
CN	Refrigerator Coolant	Refrigerator Coolant	string	0-9 and .(decimal number)	6	No		4.5
CO	Suspension Fluid	Suspension Fluid	string	0-9 and .(decimal number)	6	No		4.5
CP	Merchant Fee	Merchant Fee	string	No validation present	-	No		-
CQ	Account System Reference	Account System Reference	string	A-Z,0-9	8	No		ABC123
CR	Service And Maintenance Repair	Service And Maintenance Repair	string	Y or N	1	No	N	Y
CS	Accident Management Body Shop	Accident Management Body Shop	string	Y or N	1	No	N	Y
CT	Tyres	Tyres	string	Y or N	1	No	N	Y
CU	Glass	Glass	string	Y or N	1	No	N	Y
CV	MOT	MOT	string	Y or N	1	No	N	Y
CW	Breakdown	Breakdown	string	Y or N	1	No	N	Y
CX	Car	Car	string	Y or N	1	No	N	Y
CY	Commercial Under 3_5 tonne	Commercial Under 3_5 tonne	string	Y or N	1	No	N	Y
CZ	Commercial Over 3_5 tonne	Commercial Over 3_5 tonne	string	Y or N	1	No	N	Y
DA	HGV	HGV	string	Y or N	1	No	N	Y
DB	MotorBikes	MotorBikes	string	Y or N	1	No	N	Y
DC	Electric vehicles Car	Electric vehicles Car	string	Y or N	1	No	N	Y
DD	Electric vehicles LCV	Electric vehicles LCV	string	Y or N	1	No	N	Y
DE	Trailer	Trailer	string	Y or N	1	No	N	Y
DF	Fridge	Fridge	string	Y or N	1	No	N	Y
DG	Crane	Crane	string	Y or N	1	No	N	Y
DH	Wash and Vac	Wash and Vac	string	Y or N	1	No	N	Y
DI	Valet	Valet	string	Y or N	1	No	N	Y
DJ	Complimentary Refreshments	Complimentary Refreshments	string	Y or N	1	No	N	Y
DK	WiFi	Wifi	string	Y or N	1	No	N	Y
DL	Parking	Parking	string	Y or N	1	No	N	Y
DM	Disposal Charges	Disposal Charges	string	Decimal Number(format should be 00.00)	-	No		99.47
DN	Valve	Valve	string	Decimal Number(format should be 00.00)	-	No		99.47
DO	Wheel Balance	Wheel Balance	string	Decimal Number(format should be 00.00)	-	No		99.47
DP	Serving Proximity	Serving Proximity	string	should be a number between '0' and '999' (if serving proximity is not added, then 50 miles will be used as default)	3	No		955
DQ	Wheel Alignment2	Wheel Alignment2	string	Decimal Number(format should be 00.00)	-	No		99.47
DR	Wheel Alignment4	Wheel Alignment4	string	Decimal Number(format should be 00.00)	-	No		99.47
DS	Rebate Amount	Rebate Amount	string	Decimal Number(format should be 00.00)	-	No		99.47
DT	Rebate Percentage	Rebate Percentage	string	Decimal Number(format should be 00.00)	-	No		99.47

Importing a file

Preparation

1. Create a new branch with Jira task number in the branch name

2. Delete all the files within the importFiles folder to prevent accidental import of incorrect files

3. Create a folder with the current sprint number

4. Copy the file that needs to be imported

5. Go to package.json , find the line validate:suppliers

6. Modify --leaseId with the required lease Id

7. Modify --file with the relative path of the file

8. Modify --leaseCompanyName as per the lease Id

9. Modify --locale to en_GB or en_IE. Locale will be en_GB by default

10. Save the package.json

Validating locally

1. in a terminal run npm run build

2. in a terminal run npm run validate:suppliers

3. If there are no errors, push the code

Validating in workflow

1. Go to Action of Import-manger

2. Find <Environment> - on-demand-import

3. Select the branch that was created for this import

4. Enter script name as validate:suppliers

5. Leave Overrides empty or you can specify --leaseId, --leaseCompanyName or --locale if required

Importing the file

1. If the validation has passed

2. Go to Action of Import-manger

3. Find <Environment> - on-demand-import

4. Select the branch that was created for this import

5. Enter script name as validate:suppliers

6. Enter --persist in Overrides field

Importing the file via url(using postman and cloud run)

1. we can also import the file using cloud run. Go to import manager and run action DEV - deploy to cloud run with the latest branch.

2. Go to cloud run(google cloud console) and select import-manager from the services list.

3. Copy the url https://import-manager-36r2bu4izq-uc.a.run.app (This might vary for different environments)

4. Go to postman and paste this url in a post request. Then add the necessary parameters in Body->formData. Please refer image below for parameters to pass.

5. Upload the file in cloud storage(google cloud console) in the path imports/fileDrop/. Press the upload button to choose the file to import

6. After uploading run the request using postman. Set the persist parameter to false to validate the file and set it as true to import the file from cloud storage

Testing

1. Suppliers will be created under the specified group Id. This can be checked in the list of suppliers which belong to the group in DI Admin

Status: Pending Approval
Category: Protected
Authored By: Vignesh Kanthimathinathan on May 31, 2023

Revisions
04 Jan, 2024 - Revise to add FNP band and has FNP, VN-10825